Data Wizard

by nickklaskala ALL

ST3/ST4 package for advanced data manipulation in delimited flat files (.csv, .psv, .tsv, .txt, .dat .etc). Supports auto detection of delimiters, Justification of delimited file, collapsing delimited files, pivoting delimited files, pop columns to end (cycling first column to end in pivoted data sets, see example), data masking(shuffle list, shuffle characters), data sampling, and converting datagrid to sql insert statements. This Package is especially helpful for ETL or any task that interfaces with delimited flat files in which you are constantly opening files and inspecting them. Allows for instant human readability and analysis.

Details

Version 1.1.10
Homepage github.com
Issues github.com
Modified 2 years ago
Last Seen 2 hours ago
First Seen 5 years ago

Installs

Total 718
Win 389
Mac 239
Linux 90

	Jan 7	Jan 6	Jan 5	Jan 4	Jan 3	Jan 2	Jan 1	Dec 31	Dec 30	Dec 29	Dec 28	Dec 27	Dec 26	Dec 25	Dec 24	Dec 23	Dec 22	Dec 21	Dec 20	Dec 19	Dec 18	Dec 17	Dec 16	Dec 15	Dec 14	Dec 13	Dec 12	Dec 11	Dec 10	Dec 9	Dec 8	Dec 7	Dec 6	Dec 5	Dec 4	Dec 3	Dec 2	Dec 1	Nov 30	Nov 29	Nov 28	Nov 27	Nov 26	Nov 25	Nov 24
Windows	2	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	1	1	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1
Mac	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Linux	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Readme

Source: raw.githubusercontent.com

DataWizard

//recommended bindings
// { "keys": ["alt+\\"],           "command": "datawizardjustifycolumns"},
// { "keys": ["alt+shift+\\"],     "command": "datawizardcollapsecolumns"},
// { "keys": ["alt+p"],            "command": "datawizardpivot"},
// { "keys": ["alt+shift+p"],      "command": "datawizardpivotjustify"},
// { "keys": ["alt+l"],            "command": "datawizardpop"},
// { "keys": ["alt+s"],            "command": "datawizarddistinctcolumns"},
// { "keys": ["alt+shift+s"],      "command": "datawizarddistinctcolumnformats"},
// { "keys": ["alt+j"],            "command": "datawizarddistinctcolumnstojson"},
// { "keys": ["alt+shift+j"],      "command": "datawizarddistinctcolumnformatstojson"},
// { "keys": ["alt+i"],            "command": "datawizardstatisticssampledelimiteddiffs"},
// { "keys": ["alt+q"],            "command": "datawizardconverttosqlinsertpostgres"},


//not neccessary to map these but you can if wanted.
//sense these are less common i really just use the context menu for these actions by right clicking in the canvas

// {"keys":["alt+?"],"command":"datawizarddistinctchars"},
// {"keys":["alt+?"],"command":"datawizardkeepdelimiters"},
// {"keys":["alt+?"],"command":"datawizardleadingzerosadd"},
// {"keys":["alt+?"],"command":"datawizardleadingzerosremove"},
// {"keys":["alt+?"],"command":"datawizardsqltolowercaser"},
// {"keys":["alt+?"],"command":"datawizardpyvartotext"},
// {"keys":["alt+?"],"command":"datawizardrandomshufflecolumnvertically"},
// {"keys":["alt+?"],"command":"datawizardrandomshufflecharvertically"},
// {"keys":["alt+?"],"command":"datawizardconverttosqlinsert"},
// {"keys":["alt+?"],"command":"datawizardopenchrometab"},
// {"keys":["alt+?"],"command":"datawizardformatjson"},

Justify Collapse Columns (auto detects delimiters) Justify_Collapse